﻿<%@ Page Title="" Language="C#" MasterPageFile="~/MasterPage.master" AutoEventWireup="true" CodeFile="frmContacto.aspx.cs" Inherits="frmContacto" %>

<asp:Content ID="Content1" ContentPlaceHolderID="head" Runat="Server">
    <style type="text/css">
        .style3
        {
           font-weight: normal;
        }
        .style4
        {
            font-size: x-large;
        }
        .style16
        {
            width: 552px;
        }
        .style17
        {
            width: 483px;
        }
        .style18
        {
            width: 483px;
            height: 53px;
        }
        .style20
        {
            width: 552px;
            height: 53px;
        }
        .style21
        {
            width: 483px;
            height: 70px;
        }
        .style23
        {
            width: 552px;
            height: 70px;
        }
        .style24
        {
            font-size: xx-small;
            
        }
                
        .style27
        {
            position: absolute;
            left: 263px;
            top: 364px;
        }
        
        .style28
        {
            position: absolute;
            left: 263px;
            top: 395px;
            width: 316px;
        }
        
        .style29
        {
            position: absolute;
            left: 642px;
            top: 222px;
            height: 28px;
        }
        
        .style30
        {
            position: absolute;
            left: 275px;
            top: 252px;
            width: 312px;
        }
        
        .style32
        {
            position: absolute;
            left: 584px;
            top: 517px;
            width: 8px;
        }
        
        .style33
        {
            position: absolute;
            top: 218px;
            left: 275px;
            height: 30px;
        }
        
        .style34
        {
            position: absolute;
            left: 584px;
            top: 371px;
        }
        
        .style35
        {
            position: absolute;
            left: 639px;
            top: 254px;
        }
        
        .style36
        {
            position: absolute;
            left: 584px;
            top: 401px;
        }
        
        .style37
        {
            position: absolute;
            left: 270px;
            top: 432px;
            width: 80px;
            height: 30px;
        }
        
        .style38
        {
            position: absolute;
            left: 352px;
            top: 429px;
            width: 224px;
        }
        
        .style39
        {
            position: absolute;
            left: 584px;
            top: 434px;
        }
        
        .style40
        {
            position: absolute;
            left: 380px;
            top: 566px;
        }
        
        .style41
        {
            position: absolute;
            left: 352px;
            top: 457px;
            width: 150px;
        }
        
        .style42
        {
            position: absolute;
            left: 265px;
            top: 517px;
            width: 312px;
        }
        
        .style43
        {
            position: absolute;
            left: 585px;
            top: 486px;
        }
        
        .style44
        {
            position: absolute;
            left: 351px;
            top: 482px;
            width: 226px;
        }
        
        .style45
        {
            position: absolute;
            left: 263px;
            top: 488px;
            width: 85px;
            height: 30px;
        }
        
        .style46
        {
            position: absolute;
            left: 198px;
            top: 627px;
            width: 1020px;
        }
        
        .style47
        {
            position: absolute;
            left: 1120px;
            top: 363px;
        }
        
        .style48
        {
            position: absolute;
            left: 815px;
            top: 363px;
        }
        
        .style49
        {
            position: absolute;
            left: 815px;
            top: 428px;
            right: 433px;
        }
        
        .style50
        {
            position: absolute;
            left: 954px;
            top: 395px;
        }
        
        .style51
        {
            position: absolute;
            left: 815px;
            top: 395px;
            width: 98px;
        }
        
        .style52
        {
            position: absolute;
            left: 818px;
            top: 549px;
            width: 241px;
            height: 27px;
        }
        
        .style53
        {
            position: absolute;
            left: 817px;
            top: 513px;
            width: 242px;
            height: 27px;
        }
        
        .style54
        {
            position: absolute;
            left: 815px;
            top: 479px;
            width: 243px;
            height: 27px;
        }
        
        .style55
        {
            position: absolute;
            left: 202px;
            top: 704px;
        }
        
        .style56
        {
            position: absolute;
            left: 396px;
            top: 705px;
        }
        
        .style57
        {
            position: absolute;
            left: 580px;
            top: 705px;
        }
        
        .style58
        {
            position: absolute;
            left: 770px;
            top: 705px;
            right: 400px;
        }
        
        .style59
        {
            position: absolute;
            left: 194px;
            top: 207px;
            width: 1028px;
            height: 88px;
        }
        .style60
        {
            position: absolute;
            left: 5px;
            top: 15px;
            z-index: 1;
        }
        .style61
        {
            position: absolute;
            left: 28px;
            top: 46px;
            z-index: 1;
        }
        .style62
        {
            position: absolute;
            top: 327px;
            left: 211px;
            z-index: 1;
            width: 112px;
        }
        .style63
        {
            position: absolute;
            top: 329px;
            left: 748px;
            z-index: 1;
        }
        .style64
        {
            position: absolute;
            top: 369px;
            left: 201px;
            z-index: 1;
        }
        .style65
        {
            position: absolute;
            top: 398px;
            left: 201px;
            z-index: 1;
        }
        .style67
        {
            position: absolute;
            top: 435px;
            left: 198px;
            z-index: 1;
        }
        .style68
        {
            position: absolute;
            top: 524px;
            left: 216px;
            z-index: 1;
        }
        .style69
        {
            position: absolute;
            top: 490px;
            left: 204px;
            z-index: 1;
        }
        .style70
        {
            position: absolute;
            top: 433px;
            left: 742px;
            z-index: 1;
        }
        .style71
        {
            position: absolute;
            top: 516px;
            left: 752px;
            z-index: 1;
        }
        .style72
        {
            position: absolute;
            top: 480px;
            left: 769px;
            z-index: 1;
        }
        .style73
        {
            position: absolute;
            top: 548px;
            left: 753px;
            z-index: 1;
            width: 63px;
            height: 27px;
        }
        .style74
        {
            position: absolute;
            top: 371px;
            left: 768px;
            z-index: 1;
        }
        .style75
        {
            position: absolute;
            top: 402px;
            left: 773px;
            z-index: 1;
        }
        .style76
        {
            position: absolute;
            top: 400px;
            left: 920px;
            z-index: 1;
        }
        .style77
        {
            position: absolute;
            top: 372px;
            left: 1089px;
            z-index: 1;
        }
        .style78
        {
            position: absolute;
            top: 607px;
            left: 200px;
            z-index: 1;
        }
        .style79
        {
            position: absolute;
            left: 193px;
            top: 321px;
            width: 500px;
            height: 263px;
        }
        .style80
        {
            position: absolute;
            left: 709px;
            top: 321px;
            width: 513px;
            height: 263px;
        }
        .style81
        {
            position: absolute;
            left: 191px;
            top: 599px;
            width: 1032px;
            height: 88px;
        }
        .style82
        {
            position: absolute;
            left: 192px;
            top: 695px;
            width: 1032px;
            height: 43px;
        }
        
        .style83
        {
            position: absolute;
            left: 322px;
            top: 566px;
            right: 669px;
        }
        
        .style84
        {
            position: absolute;
            top: 227px;
            left: 149px;
            z-index: 1;
        }
        
        </style>
</asp:Content>
<asp:Content ID="Content2" ContentPlaceHolderID="ContentPlaceHolder2" Runat="Server">
<h4>Menu</h4>
        <br>
        <p>
        <a href="frmEmpresa.aspx">Empresa</a>
        <br>
        <a href="frmListaDeEstablecimientos.aspx">Establecimientos</a>
        <br>
        <a href="frmContacto.aspx">Contactos</a>
        <br>
        <a href="frmEmpleados.aspx">Empleados</a>
        <br>
      
        </p>
</asp:Content>
<asp:Content ID="Content3" ContentPlaceHolderID="ContentPlaceHolder1" Runat="Server">
    
       <p>  <h1>Registrar Contacto</h1>
       
   
                <b>
       <br />
       &nbsp;&nbsp;</b><asp:TextBox ID="TextBox8" runat="server" 
           Font-Bold="True" CssClass="style33"
            Width="312px" CausesValidation="True" 
                    BackColor="#DDEDEE"></asp:TextBox>
                <b>&nbsp; &nbsp;&nbsp; 
                <asp:DropDownList ID="DropDownList1" runat="server" 
            DataSourceID="SqlDataSourceEmpresas" DataTextField="nombreComercial" CssClass="style29"
            DataValueField="cuit" Width="253px" Visible="False" 
                    BackColor="#DDEDEE">
        </asp:DropDownList>
        <asp:Button ID="Button4" runat="server" CausesValidation="False" Height="30px" CssClass="style35" 
            onclick="Button4_Click" Text="Seleccionar Empresa" Width="183px" 
           Visible="False" />
                <br />
                &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &nbsp;<asp:TextBox 
            ID="TextBox9" runat="server" Font-Bold="True" Height="30px" CssClass="style30"
                    CausesValidation="True" BackColor="#DDEDEE"></asp:TextBox>
                <asp:RequiredFieldValidator ID="RequiredFieldValidator6" 
           runat="server" CssClass="style32"
                    ControlToValidate="TBEmail" Font-Bold="True" ForeColor="Red" 
                    ValidationGroup="2">*</asp:RequiredFieldValidator>
&nbsp; &nbsp;&nbsp;
                <br />
                &nbsp;<asp:Panel 
           ID="Panel1" runat="server" BorderStyle="Groove" 
           CssClass="style59">
           <asp:Label ID="Label8" runat="server" CssClass="style60" Text="Empresa:"></asp:Label>
           <asp:Label ID="Label9" runat="server" CssClass="style61" 
               Text="CUIT:"></asp:Label>
    </asp:Panel>
       </b>
                <b>
       <asp:Panel 
           ID="Panel2" runat="server" BorderStyle="Groove" 
           CssClass="style79">
           <asp:RegularExpressionValidator ID="RegularExpressionValidator1" runat="server" CssClass="style84" 
    ErrorMessage="Ingrese E-Mail Valido" ControlToValidate="TBEmail" ForeColor="Red" 
               ValidationExpression="\w+([-+.']\w+)*@\w+([-.]\w+)*\.\w+([-.]\w+)*" 
               ValidationGroup="2"></asp:RegularExpressionValidator>
    </asp:Panel>
       </b></p>
    <table class="style13">
        <tr>
            <td class="style18">
                <p>
                    <strong>
                    <asp:Label ID="Label11" runat="server" CssClass="style62" 
                        Text="Datos Contacto:"></asp:Label>
                    </strong>&nbsp;</p>
            </td>
            
            <td class="style20">
                <strong>
                <asp:Label ID="Label12" runat="server" CssClass="style63" Text="Domicilio:"></asp:Label>
                </strong></td>
        </tr>
        <tr>
            <td class="style17">
                <p>
                    &nbsp;&nbsp;<asp:Label ID="Label13" runat="server" CssClass="style64" 
                        Text="Nombre:"></asp:Label>
&nbsp;<asp:TextBox ID="TBNombre" runat="server" CssClass="style27"  Height="30px" Width="315px" ValidationGroup="1" 
                        BackColor="#DDEDEE"></asp:TextBox>
                    
                    <asp:RequiredFieldValidator ID="RequiredFieldValidator1" CssClass="style34" runat="server" 
                        ControlToValidate="TBNombre" Font-Bold="True" ForeColor="Red" 
                        ValidationGroup="2">*</asp:RequiredFieldValidator>
                    
        
                                        
                    </p>
            </td>
            
            <td class="style16">
        &nbsp;<asp:TextBox ID="TBCalle" runat="server" Width="264px" Height="30px" CssClass="style48"
                    BackColor="#DDEDEE"></asp:TextBox>
        &nbsp;<asp:TextBox ID="TBNroCalle" runat="server" Width="69px" Height="30px" CssClass="style47"
                    BackColor="#DDEDEE"></asp:TextBox>
                &nbsp;<asp:TextBox ID="TBPiso" runat="server" Height="30px" CssClass="style51"
                    BackColor="#DDEDEE"></asp:TextBox>
            </td>
        </tr>
        <tr>
            <td class="style17">
                <p>
                    &nbsp;&nbsp;
        <asp:TextBox ID="TBApellido" runat="server" Font-Bold="False" Height="30px" CssClass="style28"
                        ValidationGroup="1" BackColor="#DDEDEE"></asp:TextBox>
                    <asp:RequiredFieldValidator ID="RequiredFieldValidator2" runat="server" CssClass="style36"
                        ControlToValidate="TBApellido" Font-Bold="True" ForeColor="Red" 
                        ValidationGroup="2">*</asp:RequiredFieldValidator>
                    <asp:Label ID="Label14" runat="server" CssClass="style65" Text="Apellido:"></asp:Label>
                </p>
                
            </td>
          
            <td class="style16">
                &nbsp;<asp:TextBox ID="TBDpto" runat="server" Width="83px" 
                    Height="30px" CssClass="style50"
                    BackColor="#DDEDEE"></asp:TextBox>
                    &nbsp;&nbsp;
        <asp:TextBox ID="TBCodPostal" runat="server" Width="98px" Height="30px" CssClass="style49"
                    BackColor="#DDEDEE"></asp:TextBox>
                <asp:Label ID="Label19" runat="server" CssClass="style74" Text="Calle"></asp:Label>
                <asp:Label ID="Label21" runat="server" CssClass="style75" Text="Piso"></asp:Label>
                <asp:Label ID="Label22" runat="server" CssClass="style76" Text="Dpto."></asp:Label>
                <asp:Label ID="Label23" runat="server" CssClass="style70" Text="Cod.Postal"></asp:Label>
            </td>
        </tr>
        <tr>
            <td class="style21">
    <p>
                    <asp:DropDownList ID="DropTipoDNI" runat="server" CssClass="style37"
            DataSourceID="DSTipoDNI" DataTextField="descripcionTipoDocumento" 
            DataValueField="idTipoDocumento" BackColor="#DDEDEE">
        </asp:DropDownList>
                    <asp:TextBox ID="TBNroDNI" CssClass="style38" runat="server" Height="30px" 
                        BackColor="#DDEDEE"></asp:TextBox>
                    &nbsp;&nbsp;&nbsp;<asp:RequiredFieldValidator ID="RequiredFieldValidator3" CssClass="style39"
                        runat="server" ControlToValidate="TBNroDNI" Font-Bold="True" ForeColor="Red" 
                        ValidationGroup="2">*</asp:RequiredFieldValidator>
                    <span 
            class="style4">
        <asp:Label ID="Label6" runat="server" CssClass="style40" Font-Bold="True" Font-Size="Small" 
                        ForeColor="Red"></asp:Label>
        </span>
                </p>
                <p>
                    <span class="style5"><strong>
                     <asp:RangeValidator ID="RangeValidator1" runat="server" CssClass="style41"
                         ControlToValidate="TBNroDNI" ErrorMessage="Ingrese DNI Valido" Font-Bold="True" 
                         ForeColor="Red" MaximumValue="99999999" MinimumValue="1111111" 
                         SetFocusOnError="True" Type="Integer" ValidationGroup="2"></asp:RangeValidator>
                     </strong>
                    
                     </span>&nbsp;<asp:Label ID="Label16" runat="server" CssClass="style67" 
                        Text="Documento"></asp:Label>
                </p>
                <p>
                    &nbsp;</p>
            </td>
           
            <td class="style23">
                    &nbsp;
        <asp:DropDownList ID="DropProvincia" runat="server" DataSourceID="DSProvincia" 
            DataTextField="nombreProvincia" DataValueField="idProvincia" CssClass="style52" 
                        BackColor="#DDEDEE">
        </asp:DropDownList>
                    <asp:Label ID="Label24" runat="server" CssClass="style72" Text="Barrio"></asp:Label>
                    <br />
        &nbsp;<asp:DropDownList ID="DropLocalidad" runat="server" DataSourceID="DSLocalidad" 
            DataTextField="nombreLocalidad" DataValueField="idLocalidad" CssClass="style53" 
                        BackColor="#DDEDEE">
        </asp:DropDownList>
        &nbsp;
                    <asp:Label ID="Label20" runat="server" CssClass="style77" Text="Nro."></asp:Label>
                    <asp:Label ID="Label25" runat="server" CssClass="style71" Text="Localidad"></asp:Label>
                    <br />
                    &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;
        <asp:DropDownList ID="DropBarrio" runat="server" DataSourceID="DSBarrio" CssClass="style54"
            DataTextField="nombreBarrio" DataValueField="idBarrio" BackColor="#DDEDEE">
        </asp:DropDownList>
                    <asp:Label ID="Label26" runat="server" CssClass="style73" Text="Provincia"></asp:Label>
                </td>
        </tr>
        <tr>
            <td class="style17">
                <asp:Label ID="Label17" runat="server" CssClass="style68" Text="E-Mail"></asp:Label>
&nbsp;<asp:TextBox ID="TBEmail" runat="server" Height="30px" CssClass="style42"
                    BackColor="#DDEDEE"></asp:TextBox>
&nbsp;&nbsp;&nbsp;</td>
            
           
        </tr>
        <tr>
            <td class="style17">
                <p>
                    <asp:DropDownList ID="DropTipoTel" runat="server" DataSourceID="DSTipoTel" 
            DataTextField="descripcionTipoTelefono" DataValueField="idTipoTelefono" 
                        CssClass="style45" BackColor="#DDEDEE">
        </asp:DropDownList>
        <asp:TextBox ID="TBNroTel" runat="server" CssClass="style44" Height="30px" 
                        BackColor="#DDEDEE"></asp:TextBox>
                    <asp:RequiredFieldValidator ID="RequiredFieldValidator4" runat="server" CssClass="style43"
                        ControlToValidate="TBNroTel" Font-Bold="True" ForeColor="Red" 
                        ValidationGroup="2">*</asp:RequiredFieldValidator>
                    <asp:Label ID="Label18" runat="server" CssClass="style69" Text="Telefono"></asp:Label>
                <b>
                <asp:Panel 
           ID="Panel3" runat="server" BorderStyle="Groove" 
           CssClass="style80">
    </asp:Panel>
                <asp:Panel 
           ID="Panel4" runat="server" BorderStyle="Groove" 
           CssClass="style81">
    </asp:Panel>
       </b>
    </p>
            </td>
           
        </tr>
    </table>
    <p>
        <strong>
        <asp:Label ID="Label27" runat="server" CssClass="style78" Text="Observaciones"></asp:Label>
        </strong></p>
    <p>
        <asp:TextBox ID="TBObservaciones" runat="server" Height="59px" 
            TextMode="MultiLine" CssClass="style46" BackColor="#DDEDEE"></asp:TextBox>
    </p>
    <p>
        

        &nbsp;</p>
    <p>
        
<asp:Button ID="Button3" runat="server" onclick="Button3_Click" CssClass="style55"
            Text="Registrar" Height="32px" Width="181px" ValidationGroup="2" 
            Enabled="False" />
       
       
        <asp:Button ID="Button5" runat="server" Height="31px" CssClass="style56"
            onclick="Button5_Click" Text="Modificar Datos" Width="168px" 
            ValidationGroup="2" Enabled="False" />
        <asp:Button ID="Button6" runat="server" Height="31px" onclick="Button6_Click" CssClass="style57"
            Text="Nuevo Contacto" ValidationGroup="2" Width="173px" 
            CausesValidation="False" />
        <asp:Button ID="Button8" runat="server" Height="30px" onclick="Button8_Click" CssClass="style58"
            Text="Listar Contactos" Width="176px" />
       
                <b>
       <asp:Panel 
           ID="Panel5" runat="server" BorderStyle="Groove" 
           CssClass="style82">
    </asp:Panel>
       </b>
       

        <asp:Label ID="Label5" runat="server" Font-Bold="True" ForeColor="#003366" 
           CssClass="style83"></asp:Label>
    
        </p>
    

    <asp:ValidationSummary ID="ValidationSummary1" runat="server" 
        HeaderText="Debe Completar los Campos Obligatorios (*)" ShowMessageBox="True" 
        ShowSummary="False" ValidationGroup="2" />
    <p>
        <asp:SqlDataSource ID="DSTipoDNI" runat="server" 
            ConnectionString="<%$ ConnectionStrings:ConnectionString %>" 
            SelectCommand="SELECT * FROM [T_TipoDoc]">
        </asp:SqlDataSource>
        <asp:SqlDataSource ID="DSTipoTel" runat="server" 
            ConnectionString="<%$ ConnectionStrings:ConnectionString %>" 
            SelectCommand="SELECT * FROM [T_TipoTelefono] where habilitado &gt; 0" 
            ProviderName="<%$ ConnectionStrings:ConnectionString.ProviderName %>"></asp:SqlDataSource>
        <asp:SqlDataSource ID="DSProvincia" runat="server" 
            ConnectionString="<%$ ConnectionStrings:ConnectionString %>" 
            
            SelectCommand="SELECT idProvincia, nombreProvincia, idPais, habilitado FROM T_Provincia"></asp:SqlDataSource>
        <asp:SqlDataSource ID="DSLocalidad" runat="server" 
            ConnectionString="<%$ ConnectionStrings:ConnectionString %>" 
            
            SelectCommand="SELECT idLocalidad, nombreLocalidad, idProvincia, habilitado FROM T_Localidad"></asp:SqlDataSource>
        <asp:SqlDataSource ID="DSBarrio" runat="server" 
            ConnectionString="<%$ ConnectionStrings:ConnectionString %>" 
            SelectCommand="SELECT * FROM [T_Barrio]"></asp:SqlDataSource>
        <asp:SqlDataSource ID="DSEmpresa" runat="server" 
            ConnectionString="<%$ ConnectionStrings:ConnectionString %>" 
            
            
            
            
            SelectCommand="SELECT T_Empresa.cuit, T_Empresa.nombreComercial, T_Empresa.razonSocial, T_Barrio.nombreBarrio, T_Localidad.nombreLocalidad, T_Provincia.nombreProvincia FROM T_Empresa INNER JOIN T_Barrio ON T_Empresa.idBarrio = T_Barrio.idBarrio INNER JOIN T_Localidad ON T_Empresa.idLocalidad = T_Localidad.idLocalidad INNER JOIN T_Provincia ON T_Empresa.idProvincia = T_Provincia.idProvincia WHERE (T_Empresa.cuit = @cuit)">
            <SelectParameters>
                <asp:ControlParameter ControlID="TextBox9" Name="cuit" PropertyName="Text" />
            </SelectParameters>
        </asp:SqlDataSource>
        <asp:SqlDataSource ID="DSContacto" runat="server" 
            ConnectionString="<%$ ConnectionStrings:ConnectionString %>" 
            
            
            
            InsertCommand="INSERT INTO T_Contacto(descripcionContacto, cuit, numDocumento, nombre, apellido, idTipoDocumento, dirCorreo, idTipoTelefono, numTelefono, fechaNacimiento, observaciones, calle, numeroCalle, piso, departamento, codPostal, idBarrio, idLocalidad, idProvincia) VALUES (@descripcionContacto, @cuit, @numDocumento, @nombre, @apellido, @idTipoDocumento, @dirCorreo, @idTipoTelefono, @numTelefono, @fechaNacimiento, @observaciones, @calle, @numeroCalle, @piso, @departamento, @codPostal, @idBarrio, @idLocalidad, @idProvincia)" 
            ProviderName="<%$ ConnectionStrings:ConnectionString.ProviderName %>" 
            SelectCommand="SELECT T_Contacto.idContacto, T_Contacto.descripcionContacto, T_Contacto.cuit, T_Contacto.numDocumento, T_Contacto.nombre, T_Contacto.apellido, T_Contacto.idTipoDocumento, T_Contacto.dirCorreo, T_Contacto.idTipoTelefono, T_Contacto.numTelefono, T_Contacto.fechaNacimiento, T_Contacto.observaciones, T_Contacto.calle, T_Contacto.numeroCalle, T_Contacto.piso, T_Contacto.departamento, T_Contacto.codPostal, T_Contacto.idBarrio, T_Contacto.idLocalidad, T_Contacto.idProvincia, T_Contacto.idPais, T_Barrio.nombreBarrio, T_Localidad.nombreLocalidad, T_Provincia.nombreProvincia FROM T_Contacto INNER JOIN T_Barrio ON T_Contacto.idBarrio = T_Barrio.idBarrio INNER JOIN T_Localidad ON T_Contacto.idLocalidad = T_Localidad.idLocalidad INNER JOIN T_Provincia ON T_Contacto.idProvincia = T_Provincia.idProvincia WHERE (T_Contacto.idContacto = @id)" 
            
            UpdateCommand="UPDATE T_Contacto SET cuit = @cuit, numDocumento = @numDocumento, nombre = @nombre, apellido = @apellido, idTipoDocumento = @idTipoDocumento, dirCorreo = @dirCorreo, idTipoTelefono = @idTipoTelefono, numTelefono = @numTelefono, fechaNacimiento = @fechaNacimiento, observaciones = @observaciones, calle = @calle, numeroCalle = @numeroCalle, piso = @piso, departamento = @departamento, codPostal = @codPostal, idBarrio = @idBarrio, idLocalidad = @idLocalidad, idProvincia = @idProvincia WHERE (idContacto = @idContacto)">
            <InsertParameters>
                <asp:Parameter Name="descripcionContacto" />
                <asp:Parameter Name="cuit" />
                <asp:Parameter Name="numDocumento" />
                <asp:Parameter Name="nombre" />
                <asp:Parameter Name="apellido" />
                <asp:Parameter Name="idTipoDocumento" />
                <asp:Parameter Name="dirCorreo" />
                <asp:Parameter Name="idTipoTelefono" />
                <asp:Parameter Name="numTelefono" />
                <asp:Parameter Name="fechaNacimiento" />
                <asp:Parameter Name="observaciones" />
                <asp:Parameter Name="calle" />
                <asp:Parameter Name="numeroCalle" />
                <asp:Parameter Name="piso" />
                <asp:Parameter Name="departamento" />
                <asp:Parameter Name="codPostal" />
                <asp:Parameter Name="idBarrio" />
                <asp:Parameter Name="idLocalidad" />
                <asp:Parameter Name="idProvincia" />
                <asp:Parameter Name="idPais" />
            </InsertParameters>
            <SelectParameters>
                <asp:Parameter Name="id" />
            </SelectParameters>
            <UpdateParameters>
                <asp:Parameter Name="cuit" />
                <asp:Parameter Name="numDocumento" />
                <asp:Parameter Name="nombre" />
                <asp:Parameter Name="apellido" />
                <asp:Parameter Name="idTipoDocumento" />
                <asp:Parameter Name="dirCorreo" />
                <asp:Parameter Name="idTipoTelefono" />
                <asp:Parameter Name="numTelefono" />
                <asp:Parameter Name="fechaNacimiento" />
                <asp:Parameter Name="observaciones" />
                <asp:Parameter Name="calle" />
                <asp:Parameter Name="numeroCalle" />
                <asp:Parameter Name="piso" />
                <asp:Parameter Name="departamento" />
                <asp:Parameter Name="codPostal" />
                <asp:Parameter Name="idBarrio" />
                <asp:Parameter Name="idLocalidad" />
                <asp:Parameter Name="idProvincia" />
                <asp:ControlParameter ControlID="Label7" Name="idContacto" 
                    PropertyName="Text" />
            </UpdateParameters>
        </asp:SqlDataSource>
        <asp:SqlDataSource ID="DSContacto2" runat="server" 
            ConnectionString="<%$ ConnectionStrings:ConnectionString %>" 
            ProviderName="<%$ ConnectionStrings:ConnectionString.ProviderName %>" 
            SelectCommand="SELECT numDocumento, idContacto FROM T_Contacto WHERE (numDocumento = @numDocumento)">
            <SelectParameters>
                <asp:Parameter Name="numDocumento" />
            </SelectParameters>
        </asp:SqlDataSource>
        <asp:Label ID="Label7" runat="server" Text="Label" Visible="False"></asp:Label>
        <span 
            class="style4">
        <asp:Label ID="Label4" runat="server" 
            Visible="False" CssClass="style24"></asp:Label>
        </span>
        <asp:SqlDataSource ID="SqlDataSourceEmpresas" runat="server" 
            ConnectionString="<%$ ConnectionStrings:ConnectionString %>" 
            SelectCommand="SELECT [nombreComercial], [cuit] FROM [T_Empresa]">
        </asp:SqlDataSource>
        </p>
</asp:Content>

